SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 30
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:2 WOODS END ROAD- Well maintained 3-bed & 4-bath contemporary sited on 3 landscaped acres conveniently located just 10 minutes from downtown Hanover. A spacious and updated kitchen flows effortlessly into an open concept living & dining area with fireplace and wood stove and an expansive outdoor deck and gazebo, all of which bathes in natural light to make it a perfect setup for entertaining family and friends. On the front side of the house is another sizable living or family area, office space that is a ground floor bedroom option, and 3/4 bath. The second floor features a warm and sunlit primary suite, two additional bedrooms, and a full bath. A finished lower level complete with full bath and two versatile recreation / bonus rooms offers plenty of overflow space. Renovated mudroom on main level is dog kennel option. With easy access to area schools, recreation, restaurants, shopping, and more, this turnkey Hanover home is a must-see. Most of furnished photos are virtually staged.
Description:A classic Cape Cod, post and beam New England home, in one of the premiere and most desirable Hanover neighborhoods. Sited on 5.05 private acres, this spacious and stylish home has a modern open concept floor plan, high ceilings with stunning woodwork, is flooded with natural light, and is just a short commute to Dartmouth College and Dartmouth Health. Significant additions have taken place, including the large piano room, and twin dormered bedrooms. The kitchen, with custom cabinetry and generous prep space, is perfect for intimate meals or lively gatherings that seamlessly flow into the adjoining dining and living rooms. The first floor also has an office, half bathroom and laundry room, as well as a functional breezeway/mudroom combination. Upstairs, the primary suite has an en-suite bathroom and walk-in closet. Three additional bedrooms are spacious and versatile, perfect for residents and guests and are supported by a 3/4 bathroom. The bonus room is a clever flexible space that could be an additional office, gym or studio. Outdoors, the stone patio overlooks a setting for relaxation and entertaining. Seller upgrades include: a ~10 year old roof, refinished floors and a repainted exterior, to name a few. With its prime location, refined interiors, and exceptional craftsmanship, this home invites you to experience the best of Hanover living. **Septic was designed as a 3 bedroom system. Open House on Saturday Jan 18th, from 9-11.
Description:Marvellous contemporary cape in move-in condition with fabulous gleaming hardwood floors throughout the main level. Open first floor has spacious kitchen, dining room, living room, mudroom, office and 1/2 bath/laundry. Second floor has 3 bedrooms, 2 full bathrooms. Separate suite, accessed from mudroom has large living room or home office, bedroom, and 3/4 bath. This residential neighborhood location makes for quick and easy commuting to the medical center, without driving through Hanover, or to the College. A great one! Showings start at Open House Saturday, Jan 4, 10am-12 and Sunday, Jan 5, 2-4pm
Description:Sited on a southeast-facing ridge in the hills of Plainfield, this extraordinary estate seamlessly blends elegance, solitude, and natural beauty. The private 103 acres of pristine woodlands with multiple ponds, meandering hiking and riding trails, and views of local hills and distant mountains, offers the ultimate retreat while being just minutes from Dartmouth College, DHMC, I-89, and I-91. Its location provides both tranquility and convenient access to the best of the Upper Valley, Boston, and beyond. The residence is a unique fusion of Tuscan-inspired design, Italian elegance, and traditional New England craftsmanship. Recently renovated with meticulous attention to detail, the home features a sun-drenched, flexible floor plan with five spacious bedrooms, multiple additional spaces to use as you see fit, and a guest wing. The redesigned eat-in kitchen and breakfast nook showcase modern updates, while radiant heat, wood, and pellet stoves ensure cozy warmth. Notable features such as the observation tower provide unique spaces to relax, take in the spectacular views, and stargaze. The property is designed for both leisure and function and includes a 2-bay attached garage, 1-bay under, 3-bay detached barn, and more. There's ample space for your hobbies and all the gear. Whether exploring the trails, enjoying the ponds, or hosting in the expansive living spaces, this retreat delivers a lifestyle of unmatched serenity, privacy, luxury, and sophistication.
Description:Gorgeous Lakefront! From the moment you enter this newly renovated contemporary home, you will be greeted with views and sunshine. Luxurious renovations include a high end designer chef's kitchen with Induction Wolf Range, double ovens and built-in microwave, Sub Zero Refrigerator, Bosch Dishwasher, elegant wine cooler and gorgeous counters opening to the sun filled dining area.The easy open flow and abundant windows framing the exquisite views are sure to impress you, while the quality craftsmanship can be observed in every room from the two center stone fireplaces to the custom Dana Robes built cherry shelving. Not only do you have a light bright open floor plan with main level ensuite primary bedroom/ bath and a wrap around deck overlooking the water but you also enjoy 3 other bedroom and home office options complimented by 4 beautifully renovated custom bathrooms including the primary suite bath with sumptuous sauna. The Village abuts acres of conserved land for you to explore and the local rail trail is nearby for hiking and biking pleasure. This little piece of paradise also includes an attached two car garage, beautiful stonewalls and is located only minutes from Dartmouth Health, Dartmouth College and Mt. Cardigan. (virtual staging used)